﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using Common;
namespace DAO
{
  public  class MenuDAO
    {
        DataTable dt;
        public DataTable SelectMenu()
        {
            dt = new DataTable();
            try {
                    
                    SqlCommand cmd = new SqlCommand();
                    cmd.Connection = Connect.Connected();
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.CommandText ="Selected_Menu";
                    SqlDataAdapter da = new SqlDataAdapter();
                    da.SelectCommand = cmd;            
                    da.Fill(dt);
                    return dt;
            }
            catch {
              
            }
            return dt;
        }
    }
}
